package com.panda.web.mapper.wechatinfo;

import com.panda.web.entity.wechatinfo.UserSkill;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 技能证书Mapper接口
 * 
 * @author cpanda
 * @date 2025-03-04
 */
@Mapper
public interface UserSkillMapper extends BaseMapper<UserSkill> {

    @Delete("delete from user_skill where openid =#{openid}")
    void deleteByOpenid(String openid);
    @Select("select * from user_skill where openid=#{openid}")
    List<UserSkill> findByOpenid(String openid);
    @Select("select count(*) from user_skill where openid=#{openid}")
    int findByOpenidCount(String openid);
}
